/*
 Navicat Premium Data Transfer

 Source Server         : default
 Source Server Type    : MySQL
 Source Server Version : 80015
 Source Host           : localhost:3306
 Source Schema         : clothshop

 Target Server Type    : MySQL
 Target Server Version : 80015
 File Encoding         : 65001

 Date: 24/06/2019 14:59:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cloth_type
-- ----------------------------
DROP TABLE IF EXISTS `cloth_type`;
CREATE TABLE `cloth_type` (
  `id` int(11) NOT NULL,
  `cloth_type` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of cloth_type
-- ----------------------------
BEGIN;
INSERT INTO `cloth_type` VALUES (1, '毛衣');
INSERT INTO `cloth_type` VALUES (6, '短裤');
INSERT INTO `cloth_type` VALUES (7, '长袖');
INSERT INTO `cloth_type` VALUES (3, '裙子');
COMMIT;

-- ----------------------------
-- Table structure for clothes
-- ----------------------------
DROP TABLE IF EXISTS `clothes`;
CREATE TABLE `clothes` (
  `id` int(11) NOT NULL,
  `barcode` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `cloth_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `color` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cost` double NOT NULL,
  `dprice` double NOT NULL,
  `img` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `import_date` datetime DEFAULT NULL,
  `material` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price` double NOT NULL,
  `quantity` int(11) NOT NULL,
  `sex` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `size` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `supplier` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cloth_type_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK4jcuufr2ph8h7tpwd3tkbkg5x` (`cloth_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of clothes
-- ----------------------------
BEGIN;
INSERT INTO `clothes` VALUES (5, '1001', '耐克上衣', '红色', 111, 200, NULL, NULL, NULL, 0, 102, NULL, 'M', NULL, NULL);
INSERT INTO `clothes` VALUES (8, '1002', '阿迪上衣', '黄色', 222, 400, NULL, NULL, NULL, 0, 520, NULL, 'L', NULL, NULL);
INSERT INTO `clothes` VALUES (23, '1003', '芬迪裙子', NULL, 2000, 2333, NULL, NULL, NULL, 0, 20, NULL, 'S', NULL, NULL);
INSERT INTO `clothes` VALUES (25, '1004', '芬迪上衣', NULL, 9999, 18888, NULL, NULL, NULL, 0, 99, NULL, 'L', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for hibernate_sequence
-- ----------------------------
DROP TABLE IF EXISTS `hibernate_sequence`;
CREATE TABLE `hibernate_sequence` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of hibernate_sequence
-- ----------------------------
BEGIN;
INSERT INTO `hibernate_sequence` VALUES (27);
INSERT INTO `hibernate_sequence` VALUES (27);
INSERT INTO `hibernate_sequence` VALUES (27);
COMMIT;

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `item_sum` int(11) NOT NULL,
  `order_detail` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `order_time` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total_money` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of orders
-- ----------------------------
BEGIN;
INSERT INTO `orders` VALUES (20, 4, '【T恤，L，2】，【背心，L，1】，【卫衣，XL，1】，', '2019-03-08', 392);
INSERT INTO `orders` VALUES (21, 100, '【耐克上衣，XL，99】，【阿迪上衣，XL，1】，', '2019-05-08', 40000);
INSERT INTO `orders` VALUES (22, 20, '【阿迪上衣，S，20】，', '2019-06-10', 8000);
COMMIT;

-- ----------------------------
-- Table structure for payment
-- ----------------------------
DROP TABLE IF EXISTS `payment`;
CREATE TABLE `payment` (
  `id` int(11) NOT NULL,
  `clothes` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price` double NOT NULL,
  `size` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sum` int(11) NOT NULL,
  `total` double NOT NULL,
  `orders_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK2tuuxhx91545ge3pvefdhr9g7` (`orders_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Table structure for system_users
-- ----------------------------
DROP TABLE IF EXISTS `system_users`;
CREATE TABLE `system_users` (
  `id` int(11) NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `permission` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `role` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of system_users
-- ----------------------------
BEGIN;
INSERT INTO `system_users` VALUES (1, 'soul', 'view', 'user', 'soul');
INSERT INTO `system_users` VALUES (2, 'admin', 'view,edit', 'admin', 'admin');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
